HousingInfoStudent 
EntityType  Dependent 
Logical Entity Name  HousingInfoStudent 
Default Table Name  SsStudHousingInfo 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

HousingInfoStudent Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
StudentEnrollmentPeriodId(PK)(FK)    INTEGER  NO 
 
IsHousingRequired    BIT  NO 
 
RoommateGenderPreference    CHAR(1)  NO 
 
SmokingPreference    CHAR(1)  NO 
 
MonthlyFee    MONEY(19, 4)  NO 
 
Note    VARCHAR(4000)  YES 
 
IsPlacedBySchool    BIT  NO 
 
MoveInDate    DATETIME  YES 
 
MoveOutDate    DATETIME  YES 
 
StudentServicesRoomId(FK)    INTEGER  YES 
 
StudentServicesLocationId(FK)    INTEGER  YES 
 
RoomNumber    VARCHAR(20)  YES 
 
LastModifiedUserId(FK)    INTEGER  NO 
 
CreatedDateTime    DATETIME  NO 
 
LastModifiedDateTime    DATETIME  NO 
 
RowVersion    TIMESTAMP/DATE  NO 
 
StudentServicesRoomTypeId(FK)    INTEGER  YES 
 

HousingInfoStudent Keys 
Key Name  Key Type  Keys 
SsStudHousingInfo_SsRoomID_N_N_IDX  Inversion Entry  StudentServicesRoomId 
SsStudHousingInfo_SsLocationID_N_N_IDX  Inversion Entry  StudentServicesLocationId 
SsStudHousingInfo_UserID_N_N_IDX  Inversion Entry  LastModifiedUserId 
SsStudHousingInfo_SsRoomTypeID_N_N_IDX  Inversion Entry  StudentServicesRoomTypeId 
SsStudHousingInfo_AdEnrollID_U_C_IDX  PrimaryKey  StudentEnrollmentPeriodId 

HousingInfoStudent Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
StudentEnrollmentPeriod  Identifying  One To Zero or More        StudentEnrollmentPeriodId  NO 
StudentServicesLocation  Non-Identifying  Zero or One to Zero or More        StudentServicesLocationId  NO 
StudentServicesRoom  Non-Identifying  Zero or One to Zero or More        StudentServicesRoomId  NO 
StudentServicesRoomType  Non-Identifying  Zero or One to Zero or More        StudentServicesRoomTypeId  NO 
Staff  Non-Identifying  One To Zero or More        LastModifiedUserId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

HousingInfoStudent Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_SsStudHousingInfo_MoveOutDate  ([MoveOutDate] >= [MoveInDate]) 

HousingInfoStudent Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.HousingInfoStudent 
NO       
Physical (Microsoft SQL Server)
dbo.SsStudHousingInfo 
NO       

HousingInfoStudent Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Physical (Microsoft SQL Server)  Main Model 

HousingInfoStudent Data Movement Rules 
Name  Type  Rule Text/Value